The PC-SIG Library 10/The PC-Sig Library - Shareware for the IBM PC and Compatibles (PC-SIG)(Tenth Edition Disks 1-2804)(1991).iso/PC_SIGCD/10/9/DISK1095.ZIP/USER.DOC

Text File | 1988-03-03 | 42KB | 1,093 lines

.cw 10
             SAMPLE USER & PROGRAMMER DOCUMENTATION


.FO                                i
                    T A B L E   O F   C O N T E N T S

  1. THE CUSTOMER INFORMATION SYSTEM....................................1-1

  2. SYSTEM MENU........................................................2-1
     2.1. CUSTOMER INFORMATION SYSTEM...................................2-1
          2.1.1. THE CUSTOMER FILE MAINTENANCE..........................2-5
          2.1.2« PRIN╘ CUSTOME╥ REPORT..................................2-27
          2.1.3. PRINTING MAILING LABELS................................2-31
          2.1.4. GENERATE FORM LETTER...................................2-34
          2.1.5. CUSTOMER FILE CLEANUP..................................2-37
          2.1.6. MOVE PURCHASE AMOUNTS BACK ONE YEAR....................2-39
          2.1.7. RETURNING TO SYSMENU...................................2-41



Appendices

  A. INDEX...............................................................A-1
.PAè.FO                                       ii
                               L I S T   O F   S C R E E N S


 2-1: A>..................................................................2-1
 2-2: dBASE ENTRY.........................................................2-2
 2-3: dBASE ENTRY 2.......................................................2-3
 2-4: SMITH'S BIKEWORKS INFORMATION SYSTEM................................2-4
 2-5: SMITH'S BIKEWORKS INFORMATION SYSTEM................................2-5
 2-6: SMITH'S BIKEWORKS INFORMATION SYSTEM................................2-6
 2-7: SMITH'S BIKEWORKS INFORMATION SYSTEM................................2-7
   .
   .
 2-17: >> Customer Information System File Maintenance <<.................................................2-18
   .
   .
 2-43: * END RUN dbase III PLUS...........................................................................2-44
.PAè.FO                                       iii
                          L I S T   O F   Q U E S T I O N S

 2-1: Why do you want to type dbase at A>?................................2-2
 2-2: Why must a second disk be inserted?.................................2-2
 2-3: Why must you type DO SYSMENU?.......................................2-3
 2-4: What  choice  do  you select to enter  the  customer  information...2-4
 2-5: What does the customer file maintenance do?.........................2-5
 2-6: What does the Find command do?......................................2-6
 2-7: Why must you type Ctrl-Y?...........................................2-7
 2-8: How does the system search for the customer requested?..............2-8
 2-9: What choice will allow you to add a record?.........................2-9
 2-10: Why do you enter ALBERTI?.........................................2-10
 2-11: How many possible indexes are there for the CUSTOMER file?........2-11
 2-12: How many dbf file does the customer information system maintain?..2-12
 2-13: What information does the CUSTOMER file maintain?.................2-13
 2-14: What must you do if you want to add another record?...............2-15
 2-15: Does the delete in the mainenance program remove the record.......2-16
 2-16: Why does pressing D again recalls the record?.....................2-17
 2-17: What if you want to edit another record?..........................2-18
 2-18: What does the Pg Dn key do?.......................................2-19
 2-19: Which record does the edit command work on?.......................2-20
 2-20: Why is the record number not sequential?..........................2-21
 2-21: What will happen if you are at the bottom of a file?..............2-22
 2-22: Which key would you select if you want to order the file by zip?..2-23
 2-23: What if you want to index the file by company?....................2-24
 2-24: What will the next record be?.....................................2-25
 2-25: What choice do you select to return to the menu?..................2-26
 2-26: Can you list only a certain range of customers?...................2-27
 2-27: Can you list the entire file?.....................................2-28
.PAè.PN 1
.FO                                2-#

1. THE CUSTOMER INFORMATION SYSTEM
This section documents the customer information system.


.HE                                       CUSTOMER INFORMATION SYSTEM

Customer Information
1.1. OPERATING SYSTEM
 1.1.1. STARTING UP
  Loading up dbase.

 SCREEN 1-1: STARTING UP
/---------------------------------------------------------------------------\

A>

\---------------------------------------------------------------------------/


Look at the screen, and find the "A>".

To me, it shows that the computer (defaults and/or) expects me to
inser⌠ disδ ▒ oµ thσ Dbasσ II╔ plu≤ prograφ iε drivσ ┴ anΣ áthσ ì
Smith'≤ Bikework≤ prograφ diskettσ iε drivσ B.

Next¼á ╔á wan⌠ t∩ typσ dbasσ anΣ pres≤ return¼á becausσ ╔ wan⌠ t∩ ì
loaΣ dbase.



INSER╘║ Disδ ▒ oµ thσ dBAS┼ II╔ PLU╙ prograφ iε drivσ A

INSER╘║ SmitΦ's Bikework≤ prograφ diskettσ iε drivσ B

TYPE:  DBASE

PRESS:  [<-']  Enter/Return key

AND THE SYSTEM WILL:  Load up dbase.


Q&A 1-1: Why do you want to type DBASE at A>?

.PAè SCREEN 1-2: dBASE III PLUS
/--------------------------------------------------------------------------\
┌─────────────────────────────────────────────────────────────────────────────┐
│                 dBASE III PLUS  version 1.0  IBM/MSDOS DEMO                 │
│      Copyright (c) Ashton-Tate 1984, 1985, 1986.  All Rights Reserved.      │
│              dBASE, dBASE III, dBASE III PLUS, and Ashton-Tate              │
│                        are trademarks of Ashton-Tate                        │
│                                                                             │
│                                                                             │
│       You may use the dBASE III PLUS software and  printed materials in     │
│       the dBASE III PLUS software package under the terms  of the dBASE     │
│       III  PLUS  Software  License Agreement.   In summary, Ashton-Tate     │
│       grants you a paid-up,  non-transferable,  personal license to use     │
│       dBASE III PLUS on one  microcomputer or workstation.   You do not     │
│       become the owner of  the package,  nor do  you have  the right to     │
│       copy or alter the software or printed materials.  You are legally     │
│       accountable  for any violation of  the  License  Agreement  or of     │
│       copyright, trademark, or trade secret laws.                           │
└─────────────────────────────────────────────────────────────────────────────┘

                           Press the F1 key for HELP.
       Insert Sampler Disk 2 and press ENTER, or press Ctrl-C to abort.
\--------------------------------------------------------------------------/


Looδ a⌠ thσ screen¼ anΣ finΣ thσ messagσ belo≈ thσ copyrigh⌠ warning.

To me, it shows that the computer (defaults and/or) expects me to
insert the second disk and press return.

Next¼ ╔ wan⌠ t∩ inser⌠ thσ seconΣ Dbasσ II╔ plu≤ disδ anΣ pres≤ return¼ ì
becausσ ╔ wan⌠ t∩ continuσ loadinτ dbase.



INSERT║  Disδ ▓ oµ thσ dBAS┼ II╔ PLU╙ prograφ iε drivσ A

PRESS:  [<-']  Enter/Return key

AND THE SYSTEM WILL:  Continue loading dbasσ anΣ displa∙ thσ dbasσ prompt.





Q&A 1-2: Why must a second disk be inserted?


.paè
 SCREEN 1-3: dBASE III PLUS
/--------------------------------------------------------------------------\
ZDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD?
│                 dBASE III PLUS  version 1.0  IBM/MSDOS DEMO                 │
│      Copyright (c) Ashton-Tate 1984, 1985, 1986.  All Rights Reserved.      │
│              dBASE, dBASE III, dBASE III PLUS, and Ashton-Tate              │
│                        are trademarks of Ashton-Tate                        │
│                                                                             │
│                                                                             │
│       You may use the dBASE III PLUS software and  printed materials in     │
│       the dBASE III PLUS software package under the terms  of the dBASE     │
│       III  PLUS  Software  License Agreement.   In summary, Ashton-Tate     │
│       grants you a paid-up,  non-transferable,  personal license to use     │
│       dBASE III PLUS on one  microcomputer or workstation.   You do not     │
│       become the owner of  the package,  nor do  you have  the right to     │
│       copy or alter the software or printed materials.  You are legally     │
│       accountable  for any violation of  the  License  Agreement  or of     │
│       copyright, trademark, or trade secret laws.                           │
└─────────────────────────────────────────────────────────────────────────────┘

                           Press the F1 key for HELP.
       Insert Sampler Disk 2 and press ENTER, or press Ctrl-C to abort.
(DEMO) .
\--------------------------------------------------------------------------/



Look at the screen, and find the "(DEMO) .ó prompt.

To me, it shows that the computer (defaults and/or) expects me to
type a dbase command.

Next¼á ╔ wan⌠ t∩ typσ D╧ SYSMEN╒ anΣ pres≤ return¼ becausσ ╔ wan⌠ ì
to display thσ firs⌠ men⌡ iε thσ Smith'≤ Bikework≤ system.


TYPE:  DO SYSMENU

PRESS:  [<-']  Enter/Return key

AND THE SYSTEM WILL:  Execute thσ SYSMENU program.



Q&A 1-3: Why must you type DO SYSMENU?



Comment║  Iµ yo⌡ usσ ß ful∞ blowε versioε oµ Dbasσ II╔ plu≤ yo⌡ wil∞ no⌠ ì
seσ thσ worΣ DEM╧ iε fron⌠ oµ thσ do⌠ prompt.
.paè 1.2. SYSMENU
Thσ systeφ men⌡ control≤ entr∙ int∩ thσ Smith'≤ Bikework≤ subsystems.

 SCREEN 1-4: Activity Menu
/--------------------------------------------------------------------------\
                       SMITH'S BIKEWORKS INFORMATION SYSTEM

                               >> Activity Menu <<

                    A. CUSTOMER INFORMATION System
                    B. HUMAN RESOURCES MANAGEMENT System
                    C. ACCOUNTING System
                    D. INVENTORY MANAGEMENT System
                    E. PRODUCTION PLANNING System
                    F. EXIT From Bikeworks' Information System

                       Press Letter Matching Desired Option
\--------------------------------------------------------------------------/


Look at the screen, and find the "Activity Menu".

To me, it shows that the computer (defaults and/or) expects me to
enter a choice between A and F.

Next¼ ╔ wan⌠ t∩ typσ A¼ becausσ ╔ wan⌠ t∩ loaΣ thσ custome≥ informatioε ì
system.



TYPE:  A

AND THE SYSTEM WILL:  Activatσ the Customer Information System.




Q&A 1-4: Ho≈ d∩ yo⌡ loaΣ thσ Custome≥ Informatioε System?





Comment║ Thσ Activit∙ Men⌡ control≤ entr∙ int∩ thσ Smith'≤ Bikework≤ ì
subsystems« I⌠ i≤ maintaineΣ a≤ par⌠ oµ thσ Custome≥ Informatioε System.


.pAè 1.3. THE CUSTOMER INFORMATION MENU
  This menu displays all the options for the customer information system.

 SCREEN 1-5: Customer Information System
/--------------------------------------------------------------------------\
                       SMITH'S BIKEWORKS INFORMATION SYSTEM

                         >> Customer Information System <<

                    A. Customer File MAINTENANCE
                    B. Print CUSTOMER REPORT
                    C. Print MAILING LABELS
                    D. Generate FORM LETTER File
                    E. CUSTOMER File CLEAN UP
                    F. Move PURCHASE AMOUNTS Back a Year
                    G. Return to SYSTEM MENU

                       Press Letter Matching Desired Option
\--------------------------------------------------------------------------/


Looδ a⌠ thσ screen¼ anΣ finΣ thσ curso≥ afte≥ thσ worΣ "Option".

To me, it shows that the computer (defaults and/or) expects me to
enter a choice from A to G.

Next¼á ╔ wan⌠ t∩ typσ A¼á becausσ ╔ wan⌠ t∩ g∩ int∩ custome≥ filσ ì
MAINTENANCE.


TYPE:  A

AN─ TH┼ SYSTE═ WILL║  LoaΣ thσ maintenancσ prograφ whicΦ i≤ nameΣ ì
CUSTMNT.PRG.




Q&A 1-5: What does the customer file maintenance do?




Comment║ Custome≥ Filσ Maintenancσ allow≤ thσ use≥ t∩ add¼ change¼ o≥ ì
deletσ record≤ iε thσ CUSTOME╥ file.

Thσ CUSTOME╥ filσ keep≤ tracδ oµ customers¼ thei≥ location¼ anΣ thσ exten⌠ ì
anΣ naturσ oµ thei≥ purchasinτ activity.
.paè1.3.1. THE CUSTOMER FILE MAINTENANCE
Thi≤ optioε allow≤ thσ use≥ t∩ add¼ change¼ o≥ deletσ record≤ iε thσì
CUSTOME╥ file.


 SCREEN 1-6: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:03/03/87     Record          6 of        7

 Name -- Last  FARMER                 First  BEN               Initial  Y
 Title    FIELD REPRESENTATIVE          Company  ROCHE BIKE WORKS
 Street   4444 5TH STREET           City  NOTHINGHAM      State  MA  Zip  33334
 Purchase Codes -- 1  99999   2  88888   3  77777
 Last Buy  01/01/85  Value This Year       0.00  Value Last Year       0.00
 Last Updated : 05/19/86
-------------------------------------------------------------------------------
  <F>ind Record  <A>dd Record   <D>elete/Recall  <E>dit Record   Current Active
  <P>rev Record  <N>ext Record  <M>enu (return)  <K>ey Select    Key: NAME
                    *** NEXT ACTION TO PERFORM
\--------------------------------------------------------------------------/


Looδ a⌠ thσ screen¼ anΣ finΣ thσ "submen⌡ oµ option≤ a⌠ thσ bottoφ oµ thσ ì
screen".

To me, it shows that the computer (defaults and/or) expects me to
enter  a command.

Next¼á ╔á wan⌠ t∩ typσ F¼á becausσ ╔ wan⌠ t∩ <F>inΣ ß recorΣ iε thσ ì
CUSTOMER file.


TYPE:  F

AN─ TH┼ SYSTE═ WILL║  Displa∙ thσ finΣ screeε witΦ aε entr∙ fielΣ ì
containinτ thσ ke∙ valuσ oµ thσ curren⌠ record.



Q&A 1-6: Wh∙ i≤ thσ ke∙ valuσ oµ tΦσ curren⌠ recorΣ displayeΣ iε thσ
         entr∙ area?





Comment║ Thσ submen⌡ oµ option≤ a⌠ thσ bottoφ oµ thσ maintenancσ screeε ì
control≤ operatioε oµ CUSTMNT.PRG« Aε optioε i≤ requesteΣ b∙ pressinτ thσ ì
lette≥ ke∙ associateΣ witΦ that option.

.paè
 SCREEN 1-7: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:03/03/87     Record          6 of        7

 Name -- Last  FARMER                 First  BEN               Initial  Y
 Title    FIELD REPRESENTATIVE          Company  ROCHE BIKE WORKS
 Street   4444 5TH STREET           City  NOTHINGHAM      State  MA  Zip  33334
 Purchase Codes -- 1  99999   2  88888   3  77777
 Last Buy  01/01/85  Value This Year       0.00  Value Last Year       0.00
 Last Updated : 05/19/86
-------------------------------------------------------------------------------
 ENTER SEARCH VALUE. VALUE NOW SHOWN IS FROM DISPLAYED RECORD. PRESS
 CTRL-Y TO CLEAR  FARMER,BEN
\--------------------------------------------------------------------------/


Looδá a⌠ thσ screen¼á anΣ finΣ thσ blinking curso≥ a⌠ thσ bottoφá oµá thσ ì
screen.

To me, it shows that the computer (defaults and/or) expects me to
press Ctrl-Y to clear the reverse video area.

Next¼ ╔ wan⌠ t∩ pres≤ Ctr∞ Y¼ becausσ ╔ wan⌠ t∩ clea≥ thσ reversσ vide∩ ì
area.


HOLD DOWN:  [Ctrl]
AND PRESS: Y

AND THE SYSTEM WILL:  Clear the entr∙ area.



Q&A 1-7: Why pres≤ Ctrl-Y?



Comment║  Reversσ vide∩ areß mean≤ aε areß oε thσ screeε tha⌠ ha≤ beeε ì
inverteΣ fo≥ easie≥ visibility.
.paè
 SCREEN 1-8: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:03/03/87     Record          6 of        7

 Name -- Last  FARMER                 First  BEN               Initial  Y
 Title    FIELD REPRESENTATIVE          Company  ROCHE BIKE WORKS
 Street   4444 5TH STREET           City  NOTHINGHAM      State  MA  Zip  33334
 Purchase Codes -- 1  99999   2  88888   3  77777
 Last Buy  01/01/85  Value This Year       0.00  Value Last Year       0.00
 Last Updated : 05/19/86
-------------------------------------------------------------------------------
 ENTER SEARCH VALUE. VALUE NOW SHOWN IS FROM DISPLAYED RECORD. PRESS
 CTRL-Y TO CLEAR
\--------------------------------------------------------------------------/


Look at the screen, and find the curso≥ iε thσ highlighteΣ entr∙ area.

To me, it shows that the computer (defaults and/or) expects me to
enter a search value.

Next¼ ╔ wan⌠ t∩ typσ ß las⌠ namσ anΣ pres≤ return¼ becausσ ╔ wan⌠ ì
t∩ looδ fo≥ ß custome≥ witΦ tha⌠ las⌠ name.


TYPE:  MUSKAT      [Mus⌠ bσ typeΣ iε uppercasσ letters.]
PRESS:  [<-']  Enter/Return key

AND THE SYSTEM WILL:  Search for a customer witΦ tha⌠ last name.




Q&A 1-8: How does the system search for the customer requested?





Comment║ AlthougΦ LAS╘ NAME,FIRS╘ NAM┼ i≤ displayed¼ onl∙ thσ LAS╘ NAM┼  ì
mus⌠ bσ entereΣ fo≥ thσ search.

Thσ namσ mus⌠ bσ entereΣ exactl∙ a≤ i⌠ appear≤ iε thσ file« Attentioε       ì
mus⌠ bσ paiΣ t∩ lowe≥ anΣ uppe≥ case.

.paè
 SCREEN 1-9: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:03/03/87     Record          6 of        7

 Namσáááá -- Las⌠áááá  MUSKA╘áááá                 Firs⌠áááá  ALA╬ Initia∞  N
 Title    JANITOR                       Company  UAS
 Stree⌠   750│ MAI╬ AP╘ ┴      Cit∙  CLEVELAN─  State  SC         zip    45555
 Purchase Codes -- 1          2          3
 Last Buy  01/01/85  Value This Year       0.00  Value Last Year       0.00
 Last Updated : 01/31/85
-------------------------------------------------------------------------------
  <F>ind Record  <A>dd Record   <D>elete/Recall  <E>dit Record   Current Active
  <P>rev Record  <N>ext Record  <M>enu (return)  <K>ey Select    Key: NAME
                    *** NEXT ACTION TO PERFORM
\--------------------------------------------------------------------------/


Look at the screen, and find the new record of customer "MUSKAT".

To me, it shows that the computer (defaults and/or) expects me to
enter the next command.

Next, I want to type A, because I want to <A>dd a record.


TYPE:  A

AN─ TH┼ SYSTE═ WILL║  Displa∙ ß blanδ recorΣ anΣ allo≈ yo⌡ t∩ ente≥ thσ ì
fielΣ values.



Q&A 1-9: What Dbasσ commanΣ allow≤ ß ne≈ recorΣ t∩ bσ addeΣ t∩ thσ database?




Comment║ Placσ thσ datß fo≥ thσ ne≈ recorΣ a⌠ thσ curso≥ positioε startinτ ì
a⌠ thσ to≡ oµ thσ screen« Movσ amonτ field≤ usinτ thσ curso≥ contro∞ keys« ì
Pres≤ RETUR╬ t∩ advancσ t∩ thσ nex⌠ field.

D∩ no⌠ pres≤ RETUR╬ afte≥ aε entr∙ tha⌠ fill≤ thσ entirσ field.
.paè
 SCREEN 1-10: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:03/03/87     Record          8 of        8

 Name -- Last                         First                    Initial
 Title                                  Company
 Street                             City                  State      Zip
 Purchase Codes -- 1          2          3
 Last Buy    /  /    Value This Year        .    Value Last Year        .
 Last Updated :   /  /
      *** PRESS 'C' TO CONTINUE ADDING NEW RECS, ANYTHING ELSE TO QUIT
-------------------------------------------------------------------------------
          Enter data at cursor position. Move among fields with
          cursor control keys. Press ENTER to move to next field.
          Press ENTER alone to leave field unchanged.
\--------------------------------------------------------------------------/


Looδ a⌠ thσ screen¼ anΣ finΣ thσ "curso≥ nex⌠ t∩ thσ iteφ "Namσ --ì
Last".

To me, it shows that the computer (defaults and/or) expects me to
enter the new customer's last name.

Next¼ ╔ wan⌠ t∩ ente≥ thσ las⌠ namσ oµ thσ ne≈ custome≥ anΣ pres≤ ì
return¼ becausσ ╔ wan⌠ t∩ adΣ ß ne≈ customer.


TYPE:  ALBERTI
PRESS:    [<-']  Enter/Return key

AN─ TH┼ SYSTE═ WILL║  Accep⌠ thσ entr∙ anΣ movσ oε t∩ thσ nex⌠ item.




Q&A 1-10: Wha⌠ command≤ arσ useΣ t∩ storσ thσ ne≈ datß typeΣ oε thσ
screeε int∩ thσ recorΣ fields?

.paèContinuσ enterinτ thσ record:

TYPE║  FRAN
PRESS║  [<-'▌  Enter/Returε key

TYPE║  A

TYP┼║  MANAGER
PRESS║  [<-'▌  Enter/Returε key


TYPE:  ALHAZME EAST
PRESS:  [<-']  Enter/Return key


TYPE:  8065 S.W 107 AVENUE
PRESS:  [<-']  Enter/Return key


TYPE:  MIAMI
PRESS:  [<-']  Enter/Return key


TYPE:  FL


TYPE:  33173


TYPE:  A
PRESS:  [<-']  Enter/Return key


TYPE:  B
PRESS:  [<-']  Enter/Return key


TYPE:  C
PRESS:  [<-']  Enter/Return key


TYPE:  011587


TYPE:  200000
PRESS:  [<-']  Enter/Return key


TYPE:  500000
PRESS:  [<-']  Enter/Return key
.paè
 SCREEN 1-11: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:02/03/87     Record          7 of        7

 Name -- Last  ALBERTI                First  FRAN              Initial  A
 Title     MANAGER                      Company  ALHAZME EAST
 Street    8065 S.W 107 AVENUE      City   MIAMI          State  FL  Zip  33173
 Purchase Codes -- 1  A       2  B       3  C
 Last Buy  01/15/87  Value This Year  200000.00  Value Last Year  500000.00
 Last Updated :   /  /
      *** PRESS 'C' TO CONTINUE ADDING NEW RECS, ANYTHING ELSE TO QUIT
-------------------------------------------------------------------------------
          Enter data at cursor position. Move among fields with
          cursor control keys. Press ENTER to move to next field.
          Press ENTER alone to leave field unchanged.
\--------------------------------------------------------------------------/


Look at the screen, and find the "messagσ a⌠ thσ bottoφ oµ thσ screen".

To me, it shows that the computer (defaults and/or) expects me to
press any key or type C to add another record.

Next¼á ╔á wan⌠ t∩ press an∙ key¼á becausσ ╔ d∩ no⌠ wisΦ t∩ adΣ an∙ ì
more records.


PRESS:  [<-']  Enter/Return key

AN─ TH┼ SYSTE═ WILL║  Updatσ thσ CUSTOME╥ filσ anΣ brinτ bacδ thσ ì
maintenance submenu.




Q&A 1-11: What must you do if you want to add another record?



.paè SCREEN 1-12: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
                 Today's Date:02/03/87     Record          7 of        7

 Name -- Last  ALBERTI                First  FRAN              Initial  A
 Title     MANAGER                      Company  ALHAZME EAST
 Street    8065 S.W 107 AVENUE      City   MIAMI          State  FL  Zip  33173
 Purchase Codes -- 1  A       2  B       3  C
 Last Buy  01/15/87  Value This Year  200000.00  Value Last Year  500000.00
 Last Updated :   /  /
-------------------------------------------------------------------------------
  <F>ind Record  <A>dd Record   <D>elete/Recall  <E>dit Record   Current Active
  <P>rev Record  <N>ext Record  <M>enu (return)  <K>ey Select    Key: NAME
                    *** NEXT ACTION TO PERFORM
\--------------------------------------------------------------------------/



Look at the screen, and find the "curso≥ afte≥ thσ worΣ PERFORM".

To me, it shows that the computer (defaults and/or) expects me to
enter the next command.

Next¼ ╔ wan⌠ t∩ typσ D¼ becausσ ╔ wan⌠ t∩ flaτ thσ currentl∙ displayeΣ ì
recorΣ fo≥ deletion.


TYPE:  D

AN─ TH┼ SYSTE═ WILL║  Flaτ thσ curren⌠ (displayeΣ) record fo≥ deletioε anΣ ì
displa∙ thσ worΣ ó ¬ DELETE─ ¬ ó iε thσ uppe≥ lef⌠ hanΣ corne≥ oµ thσ screeε.



Q&A 1-12: Does the commanΣ DELET┼ removσ ß record permanently?




Comment║ Iε orde≥ t∩ permanentl∙ removσ ß recorΣ froφ thσ CUSTOME╥ file¼ ì
thσ CUSTOME╥ Filσ CLEA╬ U≡ optioε mus⌠ bσ selecteΣ froφ thσ Custome≥ ì
Informatioε Systeφ menu«
.paè
 SCREEN 1-13: Customer Information System File Maintenance
/--------------------------------------------------------------------------\
                      SMITH'S BIKEWORKS INFORMATION SYSTEM

               >> Customer Information System File Maintenance <<
 * DELETED *     Today's Date:02/06/87     Record          6 of        7

 Name -- Last  ALBERTI                First  FRAN              Initial  A
 Title     MANAGER                      Company  ALHAZME EAST
 Street    8065 S.W 107 AVENUE      City   MIAMI          State  FL  Zip  33173
 Purchase Codes -- 1  A       2  B       3  C
 Last Buy  01/15/87  Value This Year  200000.00  Value Last Year  500000.00
 Last Updated :   »  /
--------------------------------------------------------------------------------
  <F>ind Record  <A>dd Record   <D>elete/Recall  <E>dit Record   Current Active
  <P>rev Record  <N>ext Record  <M>enu (return)  <K>ey Select    Key: NAME
                    *** NEXT ACTION TO PERFORM
\--------------------------------------------------------------------------/


Look at the screen, and find the "curso≥ afte≥ thσ worΣ PERFORM".

To me, it shows that the computer (defaults and/or) expects me to
enter the next command.

Next¼ ╔ wan⌠ t∩ typσ ─ again¼ becausσ ╔ wan⌠ t∩ recal∞ thσ deleteΣ record.


TYPE:  D

AND THE SYSTEM WILL:  Remove the flag from the deleted record.




Q&A 1-13: Why does pressing "D" again recall the record?

.paèì

.he                               Customer Programmer Doc
.pn 1
.fo                           P1-#


NOTE║  THI╙ HA╙ BEE╬ A╬ EXAMPL┼ O╞ TH┼ USE╥ DOCUMENTATIO╬ AN─ TH┼
       SAMPLE PROGRAMMER DOCUMENTATION FOLLOWS.                                       CUSTOMER INFORMATION SYSTEM

                CUSTOMER INFORMATION SYSTEMS

DESCRIPTION:
     Thσá Custome≥á Informatioεá Subsysteφ i≤ tha⌠á par⌠á oµá thσ ì
databasσá managemen⌠ proces≤ wherσ thσ custome≥ datß i≤ organizeΣ ì
anΣá storeΣ fo≥ usσ witΦ othe≥ functions«á  Usuall∙ ß systeφá oµ ì
use≥á friendl∙ softwarσ module≤ replace thσ neeΣ fo≥á specializeΣ ì
knowledgσ oµ ß certaiε databasσ package«  Thereforσ operator≤ caε ì
handlσá thσá sybsysteφ withou⌠ havinτ  t∩ kno≈ mucΦá abou⌠á dBAS┼ ì
itself.
     Thσ Custome≥ Informatioε module≤ arσ useΣ t∩ updatσ existinτ ì
databasσá file≤ anΣ retrievσ informatioε iε thσ forφ oµá reports«  ì
Thi≤ entail≤ adding¼á changing¼ anΣ deletinτ datß iε thσ databasσ ì
t∩á matcΦ curren⌠ situations¼á anΣ providinτ report≤ fo≥ feedbacδ ì
a≤ ß too∞ iε thσ decisioε makinτ process.

INPUTS:
     Smith'≤á Bikework≤á Informatioεá Systeφ i≤ aε examplσá oµá ß ì
norma∞ databasσ system«á  Thσ Custome≥ Informatioε sectioε allow≤ ì
thσá operato≥á t∩á updatσ record≤á anΣá prin⌠á custome≥á reports¼ ì
mailinτ labels¼á anΣ forφ letters«á  Addi⌠iona∞ module≤ ma∙ als∩ ì
bσá addeΣá t∩ enhancσ thσ systeφ t∩ mee⌠ thσ user'≤á needs«á  Thσ ì
actua∞ custome≥ filσ maintenancσ allow≤ thσ use≥ t∩ havσ thσ samσ ì
typσá oµá acces≤ t∩ thσ file≤ a≤ ß persoε usinτ thσá softwarσá iε ì
"immediateóá mode«á  Thσá input≤á herσ arσ simpl∙á thσá type≤á oµ ì
activitie≤ t∩ perform¼ includinτ processinτ custome≥ transaction≤ ì
anΣ allowinτ thσ operato≥ t∩ recal∞ anΣ updatσ specifiπá records«  ì
Thσá prograφá i≤ designeΣ s∩ a≤ t∩ providσ thσ maximuφ amoun⌠á oµ ì
datßá oεá onσá screen¼á anΣá t∩ organizσ i⌠ s∩á tha⌠á i⌠á i≤á no⌠ ì
difficul⌠ t∩ read«  Othe≥ input≤ arσ basicall∙ fille≥ informatioε ì
tha⌠á i≤á no⌠á stored¼áá bu⌠á i≤á useΣá t∩á makσá printout≤á morσ ì
understandablσáand efficient«á  Herσ thσ use≥ ma∙ bσ prompteΣá t∩ ì
specif∙á ßá rangσá oµ file≤ fo≥ printinτ baseΣá oεá ßá particula≥ ì
criterißá (sucΦ a≤ onl∙ thosσ name≤ les≤ thaε "E")¼á o≥ chosσ thσ ì
preferreΣáá orderinτá oµá thσá datßá (eg«áá listeΣáá b∙áá compan∙ ì
alphabetically).

PROCESSES:
     Thσá processinτá tha⌠á occur≤ iεá thσá Custome≥á Informatioε ì
Systeφá i≤ primaril∙ repor⌠ generatioε anΣ data filσá maintenance«  ì
Thσá CI╙á i≤á ß stanΣ alonσ system«á  Tha⌠ is¼á i⌠á caεá functioε ì
withou⌠á interfacinτ witΦ othe≥ systems«á  Thσ potentia∞á exists¼ ì
however¼ t∩ accesss this database for more extended processing.

     Oncσá thσ datß fo≥ thσ Bikework≤ customer≤ ha≤ beeεá stored¼ ì
i⌠á i≤á possiblσá t∩ combinσ thi≤á witΦá informatioεá froφá othe≥ ì
module≤á t∩á ge⌠ ß morσ detaileΣ listing«á  Othe≥ subsystem≤á ma∙ ì
wisΦá t∩ágain acces≤ t∩ thσ custome≥ file≤ kep⌠ iεá thσá custome≥ ìèinformatioεá systeφá eithe≥ t∩ insurσá integrity¼á o≥á t∩á updatσ ì
fields.

OUTPUTS:
     Thσá output≤ oµ thσ Custome≥ informatioε system¼á likσ most¼ ì
consis⌠ oµ differen⌠ type≤ oµ reports«á  Custome≥ listing≤ caε bσ ì
generateΣá alonτá witΦá mailinτá labelsáá anΣáá reports«áá  WitΦ ì
additiona∞ software¼ i⌠ i≤ als∩ possiblσ t∩ producσ forφ letters¼ ì
graph≤á anΣ charts«á  Thσ detai∞ oµ thσ outpu⌠ wil∞ depenΣ oε thσ ì
programming«á  Thu≤á customizeΣ report≤ caε bσ programmeΣ iεá anΣ ì
late≥á ruε b∙ aε operator«á  Operator≤ ma∙ havσ somσ inpu⌠ a≤á t∩ ì
specifiπá detail≤ iε ß particula≥ report¼á bu⌠ canno⌠ orde≥ á ß ì
ne≈ typσ oµ repor⌠ withou⌠ additiona∞ programming.

     Flexibilit∙á i≤ thσ ke∙ behinΣ thσ desigε oµá thσá database«  ì
Constan⌠á modification≤ámust be madσ t∩ thσ systeφ jus⌠ a≤á the∙ ì
mus⌠ bσ madσ t∩ record≤ a≤ thσ need≤ oµ thσ use≥ changes« ì

Thσ program≤ provideΣ iε thi≤ sectioε arσ ß stronτ beginninτ froφ ì
wherσ t∩ begiε ß use≥ specifiπ databasσ system.

.paè
                   CROSS REFERENCE FOR SYSTEM  sysmenu.prg

   _____________
  |             |
  |   SYSMENU   |    Diagram for procedure SYSMENU
  |_____________|     in system SYSMENU.PRG
         |
         |
         |------->--------.------->--------.------->--------.
         |                |                |                |
         |          ______|______    ______|______    ______|______
         |         |             |  |             |  |             |
         v         |   ACCOUNT   |  |     BOM     |  |  CUSTINFO   |
         |         |_____________|  |_____________|  |_____________|
         |
         |
         |------->--------.
         |                |
   ______|______    ______|______
  |             |  |             |
  |     HRM     |  |    INVEN    |
  |_____________|  |_____________|




.paè
   _____________
  |             |
  |   SYSMENU   |
  |_____________|
         |
         |
         |
         |
   ______v______
  |             |
  |  CUSTINFO   |    Diagram for procedure CUSTINFO
  |_____________|     in system SYSMENU.PRG
         |
         |
         |------->---.------->-------.-------->------.------->-----.
         |           |               |               |             |
 ________v_    ______|_____    ______|_____    ______|___    ______|_____
|          |  |            |  |            |  |          |  |            |
| CUSTMNT  |  |  CUSTREPT  |  |  PURCHUPD  |  |  LABELS  |  |  NAMESOUT  |
|__________|  |____________|  |____________|  |__________|  |____________|
         |
         |
         |
         |
   ______v______
  |             |
  |   CREPACK   |
  |_____________|


.paè

                      PROGRAM DESCRIPTIONS


Program:    SYSMENU.PRG         System Menu

Function:      Entry point for the entire system, displays menu of
               all subsystems and transfers control based on
               operator input.

Called by:     End-user from dBASE or DOS command level

Calls to:      ACCOUNT.PRG
               BOM.PRG
               CUSTINFO.PRG
               HRM.PRG
               INVEN.PRG



Program:    CUSTINFO.PRG        Customer Information Subsystem Menu

Function:      Entry point for Customer Information Subsystem, displays
               menu for the subsystem and transfers control based on
               operator input.

Called by:     SYSMENU.PRG

Calls to:      CUSTMNT.PRG
               CUSTREPT.PRG
               PURCHUPD.PRG
               CREPACK.PRG
               NAMESOUT.PRG
               LABELS.PRG


Program:    CUSTMNT.PRG         Customer File Maintenance Program

Function:      Maintains the customer information file (CUSTOMER.DBF).
               Available options are to add, edit, delete, recall,
               move to next record, move to previous record and find records.


Called by:     CUSTINFO.PRG

Calls to:

.paè              MEMORY AND DATABASE VARIABLES

Variable           Database           Command
Name               File               Files
--------           -------            --------------------------
ACTION                                CUSTMNT
BLANK                                 CUSTMNT
CITY               CUSTOMER           CUSTMNT NAMESOUT LABELS
COMPANY            CUSTOMER           CREPACK LABELS CUSTMNT
COUNT                                 CUSTMNT
DATAIN                                CUSTMNT
DIIXA                                 CUSTMNT
DIIXB                                 CUSTMNT
DIIXC                                 CUSTMNT
DUMMY                                 CUSTREPT PURCHUPD LABEL NAMESOUT CREPACK
FILENAME                              CUSTMNT CUSTREPT LABEL NAMESOUT
FIRST_NAME         CUSTOMER           CUSTMNT CREPACK LABELS NAMESOUT
INDEX                                 CUSTREPT LABEL NAMESOUT
INITIAL            CUSTOMER           CUSTMNT CUSTREPT LABEL NAMESOUT
IXA                                   CUSTMNT
IXB                                   CUSTMNT
IXC                                   CUSTMNT
IXCHOICE                              CUSTMNT
IXCOUNT                               CUSTMNT
IXDEF                                 CUSTMNT
LAST_NAME          CUSTOMER           CUSTMNT CREPACK LABELS CUSTREPT
LAST_PURCH         CUSTOMER           CUSTMNT
LEFTMARG                              CUSTINFO SYSMENU
LIVE_IX                               CUSTMNT
LYRS_VALUE         CUSTOMER           CUSTMNT PURCHUPD
MTYPE_1            CUSTOMER           CUSTMNT
MTYPE_2            CUSTOMER           CUSTMNT
MTYPE_3            CUSTOMER           CUSTMNT
NAMEEND                               CUSTREPT LABEL NAMESOUT
NAMEST                                CUSTREPT LABEL NAMESOUT
NOW                                   CUSTMNT
OPINPUT                               CUSTINFO SYSMENU
RECCNT                                CUSTMNT
RECNOW                                CUSTMNT LABEL
REPORT                                CUSTREPT
REQUEST                               CUSTMNT
SEARCH                                CUSTMNT
STATE              CUSTOMER           CUSTMNT LABELS NAMESOUT
STREET             CUSTOMER           CUSTMNT LABELS NAMESOUT
SV                                    CUSTMNT
TEMP                                  CUSTMNT
TEMP2                                 CUSTMNT
TITLE              CUSTOMER           CUSTMNT LABELS



.paè
                  STRUCTURE AND DATA DEFINITION

Structure for database: customer.dbf    Customer Information file
Contents:  This files contains specific information on each customer.
Size of each record: 178
Index files: NAME.NDX, COMPANY.NDX, ZIP.NDX
       keys: LAST_NAME, COMPANY, ZIP
File structure:


Field  Field Name  Type       Width    Dec   Description
    1  LAST_NAME   Character     20          Customer's last name
    2  FIRST_NAME  Character     15          Customer's first name
    3  INITIAL     Character      1          Customer's middle initial
    4  TITLE       Character     20          Customer's job title
    5  COMPANY     Character     25          Company's name
    6  STREET      Character     25          Company's street address
    7  CITY        Character     15          Company's city
    8  STATE       Character      2          Company's state
    9  ZIP         Character      5          Company's zip code
   10  MTYPE_1     Character      5          Purchase code 1
   11  MTYPE_2     Character      5          Purchase code 2
   12  MTYPE_3     Character      5          Purchase code 3
   13  LAST_PURCH  Date           8          Date of last purchase
   14  YRS_VALUE   Numeric        9    2     Current year's purchase amount
   15  LYRS_VALUE  Numeric        9    2     Last year's purchase amount
   16  LAST_UPDT   Date           8          Date of last update
** Total                        178
.paè

                 DESCRIPTION OF MEMORY VARIABLES


Variable   Command
Name       File     Type  Width  Dec  Description
--------   -------  ----  -----  ---  -----------
ACTION     CUSTMNT    C     1         User entry for action to perform
BLANK      CUSTMNT    C    80         String of spaces to blank a line
COUNT      CUSTMNT    N     1         Counter
DATAIN     CUSTMNT    C     1         Flag to cause new data to be read
DIIXA      CUSTMNT    C    80         Index key: LAST_NAME, FIRST_NAME
DIIXB      CUSTMNT    C    80         Index key: COMPANY
DIIXC      CUSTMNT    C    80         Index key: ZIP
DUMMY      CUSTREPT   C     1         User entry "M" to exit else begin
           PURCHUPD   C     1         User entry "M" to exit else begin
           LABEL      C     1         User entry "M" to exit else begin
           CREPACK    C     1         User entry "M" to exit else begin
           NAMESOUT   C     1         User entry "M" to exit else begin
FILENAME   CUSTMNT    C     8         Database file name: CUSTOMER
           CUSTREPT   C     8         Database file name: CUSTOMER
           LABEL      C     8         Database file name: CUSTOMER
           NAMESOUT   C     8         Database file name: CUSTOMER
INDEX      CUSTREPT   C     8         User specified index
           LABEL      C     8         User specified index
           NAMESOUT   C     8         User specified index
IXA        CUSTMNT    C    80         Index list: NAME,COMPANY,ZIP
IXB        CUSTMNT    C    80         Index list: COMPANY,NAME,ZIP
IXC        CUSTMNT    C    80         Index list: ZIP,NAME,COMPANY
IXCHOICE   CUSTMNT    C     1         User entry index choice
IXCOUNT    CUSTMNT    N     1         Number of indexes: 3
IXDEF      CUSTMNT    C    80         Macro defining index entries
LEFTMARG   CUSTINFO   N     2         Left margin
           SYSMENU    N     2         Left margin
LIVE_IX    CUSTMNT    C     3         Current index choice
NAMEEND    CUSTREPT   C    20         Ending LAST_NAME to include in report
           LABEL      C    20         Ending LAST_NAME to include in report
           NAMESOUT   C    20         Ending LAST_NAME to include in report
NAMEST     CUSTREPT   C    20         Beginning LAST_NAME to include in report
           LABEL      C    20         Beginning LAST_NAME to include in report
           NAMESOUT   C    20         Beginning LAST_NAMEto include in report
NOW        CUSTMNT    N     3         Current number of records
OPINPUT    CUSTINFO   C     1         User entry for menu selection
           SYSMENU    C     1         User entry for menu selection
RECCNT     CUSTMNT    N     3         Number of records in the file
RECNOW     CUSTMNT    N     3         Current record number
           LABEL      N     3         Current record number
REPORT     CUSTREPT   C     8         Report format to use: CUSTLIST
REQUEST    CUSTMNT    C     1         User entry for action to perform
SEARCH     CUSTMNT    C    80         Search value - no trailing blanks
SV         CUSTMNT    C    80         Search value


.paè                        PROGRAM FLOW

- Module SYSMENU.PRG
DO WHILE (1=1)
   DO WHILE OPINPUT<"A".OR.OPINPUT>"F"
   ENDDO
   DO CASE
   CASE OPINPUT="A"
      DO CUSTINFO
   CASE OPINPUT="B"
      DO HRM
   CASE OPINPUT="C"
      DO ACCOUNT
   CASE OPINPUT="D"
      DO INVEN
   CASE OPINPUT="E"
      DO BOM
   CASE OPINPUT="F"
      RETURN
   OTHERWISE
      CANCEL
   ENDCASE
ENDDO


- Module CUSTINFO.PRG
DO WHILE (1=1)
   DO WHILE OPINPUT<"A".OR.OPINPUT>"G"
   ENDDO
   DO CASE
   CASE OPINPUT="A"
      DO CUSTMNT
   CASE OPINPUT="B"
      DO CUSTREPT
   CASE OPINPUT="C"
      DO LABELS
   CASE OPINPUT="D"
      DO NAMESOUT
   CASE OPINPUT="E"
      DO CREPACK
   CASE OPINPUT="F"
      DO PURCHUPD
   CASE OPINPUT="G"
      RETURN
   OTHERWISE
      CANCEL
   ENDCASE
ENDDO


NOTE║  FO╥ ┴ COP┘ O╞ TH┼ ENTIR┼ USE╥ AN─ PROGRAMME╥ DOCUMENTATIO╬ ì
       MANUAL PLEASE CONTACT PRENTICE HALL  1-800-526-0485

.PAè